package com.itheima.dao.store;

import com.itheima.domain.store.Traveller;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author:项磊
 * @Description:
 * @Date: Created in 9:33 2020/12/1
 * @ModifiedBy:
 */
public interface TravellerDao {
    @Select("SELECT * FROM TRAVELLER WHERE ID = (SELECT travellerId FROM ORDER_TRAVELLER WHERE orderId = #{ordersId})")
    public List<Traveller> findTravellerByOrdersId(@Param("ordersId") String ordersId);
}
